EMT Practice Test

1. Question Content...

---

Question1: A healthcare organization needs an app to track patient encounters, patient lab orders, and patient medications.
Encounters, lab orders, and medication data are maintained in three separate tables linked by

PatientID
PatientID values in all three tables are completely accurate

Patients may have encounters without lab orders or medications

The data architect needs to make sure that the count of patient lab orders is correct.
Which method should the data architect to meet this requirement?

Question2: A data architect must break down a 13-character ShipmentID code in the following format, # ### ## ## #.
Separate fields must be created from the numeric values separated by the hyphen (-). The data architect must extract five sub-fields (ShipmentLoc, Quantity, CategoryID, StoreLoc, and Division) from the 13- character code.
How should the data architect meet this requirement?

Question3: Refer to the exhibit.

An organization stores sales data in SQL Server. A database administrator creates a view to show the transaction data. The data architect must:
Create a data model that shows the total sales for each salesperson by month

Create an indicator that shows whether the total monthly sales meet or exceed the monthly quota,

which is always $1,200
Which script should the data architect use to meet these requirements?
A:

B:

C:

D:

Question4: A health system needs to analyze patient admission and discharges in a chart with a common date axis that looks like chart below.

The initial date table (InpatientEncounters) contains a patient admission date and discharge date for each patient encounter. The data architect will use set analysis to calculate the number of admissions and discharges in the chart.

The data architect needs to design a data model with a minimum number of tables.
Which tables should the data architect create to meet these requirements?

Question5: Sales managers need to see an overview of historical performance and highlight the current year's metrics.
App requirements:
Display the current year's total sales

Total sales displayed must respond to the user's selections

Which variables should a data architect create to meet these requirements?
A:

B:

C:

D:

Question6: Refer to the exhibit.

A global company recently released an app that uses mush more memory than similar apps have used.
When reviewing data in the data manager, the data architect observes that several fields use Globally Unique Identifiers (GUIDs).
There is one key field. other fields are used to different KPIs to count the number records. The data architect must reduce the memory used as much as possible.
Which steps should a data architect take to meet these requirements?

Question7: Refer to the exhibit.

A data architect needs to build a sales dashboard. Data is stored in a legacy database. The extracted data contains the date in the format, 'YYYDDMM'. Due to the source date format, the dates are being loaded as numbers.
Which function should the data architect use to fix this issue?

Question8: Refer to the exhibit.

A data architect needs to build a dashboard that displays the aggregated sales for each sales representative. All aggregations on the data must be performed in the script.
Which script should the data architect use to meet these requirements?
A:

B:

C:

D:

Question9: Refer to the exhibits.



Business analytics report data issues in the Value field of a table since the latest reload of the data.
What causing this issue?

Question10: Refer to the exhibit.

The data architect is using section access to meet the security requirements of an app. After the first draft, the data architect discovers that users can NOT see the right subset of data.
Which solution should a data architect use to fix this issue?

Question11: Two companies have merged and full database integration is planned for next year. The data architect needs an interim solution to view all employee data from both companies.
The tables come from different systems

Both companies have similar Employees tables

Both tables have identifiers for Employee and some other attributes (e.g., geographical information)

The tables also have some fields that do NOT match (e.g., Social Security Number and Bank Account)

Which problem occurs when the two tables are loaded into Qlik Sense?

Question12: Refer to the exhibit.

Each order can have multiple products. The data architect needs to make sure the Amount can be analyzed by order Type and product Category.
The Order Number field data always contains the order Type in the first three characters. Product, Product Category, and Sales Channel data are available in an Excel spreadsheet called "Categories" in the file PaperProducts.xlsx.
Which two ways can the data architect use to make additions to the existing script and meet the requirements? (Choose two.)
A:

B:

C:

D:

Question13: Refer the exhibit.

A new app is being developed. Users need to see:
Total sales for each customer

Total sales for given state

Customers that have not had any sales

Names of salesperson and regional manager

Total number of sales by date

The data architect constructs several data models and tests the validity of each model.
Which two data models meet these requirements? (Choose two.)

Question14: Refer to the exhibit.

A data architect needs to transform the values for SalesYear from 'Sales 2016' to display only the year values '2016' and '2017' in the table.
Which two functions can the data architect use to accomplish this in the script? (Choose two.)

Question15: Refer to the exhibit.

A data architect needs to build a Project Management dashboard. The ProjectStatus table lists all indexes in the fields. Descriptions for the indexes are stored in a single Master table.
To build the dashboard, all descriptions should be in a single table:

Which function should the data architect use to meet this requirement?

Question16: Refer to the exhibits.


A company notices that product sales have decreased. A data architect needs to create an app to show the correlation between the decreased revenue and the latest customer survey results.
Which Qlik Sense feature should the data architect use to meet this requirement?

Question17: Refer to the exhibit.

The business analyst previews some data and notices different values for the United States in the Country field. The analyst must be able to report the total sales for the United States. The data architect must fix this issue in the LOAD script.
Which function should the data architect use to fix data quality issue?

Question18: Refer to the exhibit.

A fashion retail company needs to analyze data product inventory. The company needs to filter by attributes by such as color, material, and size.
Which strategy should a data architect use to meet these requirements?

Question19: Refer to the exhibit.

A QlikView app was converted to a Qlik Sense app using the Dev Hub converter.
The new Qlik Sense app was reloaded without editing the script or the server settings, which created a script error.
What should a data architect do to resolve the issue?

Question20: Refer to the exhibit.

A data architect is reviewing an app that is under development. The app as NOT been published. All data has been validated in all charts and KPIs. The data architect notices that the data model has two fact tables with common field names that cause a synthetic join.
Which step should the data architect take to correct the data model without affecting the app?

Question21: Refer to the exhibits.

A business analyst must see a currency conversion rate for any given date in a chart. The currency conversion rate data is held in a separate table in the database and only contains a record when the rate changes. An existing master calendar exists in the data model that contains a full set of dates.
Which technique should the data architect use to meet this requirement?

Question22: Stocks levels are stored online in a system that keeps information for the current period only.
What should the data architect do to enable analysis of the trends of the stock levels?

Question23: Refer to the exhibits.

Which values of the REGION field will be visible for User C when the user opens the app?